UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9cJltdZ+0q29kvSPzp1961TfKyuD6ZSrpoky81Pf+ys='
WHERE
key_id = '5116299438e99d20c26e5578914646a0e5dabf00a4e5317d42908d878c62f3df'
AND (
token = '9cJltdZ+0q29kvSPzp1961TfKyuD6ZSrpoky81Pf+ys='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)