UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NQPLnaskgITZXsL4sEpjO9fMj46JzL+eqX8cLRAionw='
WHERE
key_id = '7e9e9a1b068e237cafdb52548cd25af5f188908dcb885a2bba9677c1dd4f9103'
AND (
token = 'NQPLnaskgITZXsL4sEpjO9fMj46JzL+eqX8cLRAionw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)