UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pNc14phHKKajwvAg2R1glVSJ5sqYYTfuCqtgk/C/bZ4='
WHERE
key_id = '133c459b1d259464b8f763d0b71e91d6f49a17b9b9b594043b374165787b4f5a'
AND (
token = 'pNc14phHKKajwvAg2R1glVSJ5sqYYTfuCqtgk/C/bZ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)