UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PhhVvJV4osBuaSb4u12tFbQoljsH4mKMkDLYh2e7OS4='
WHERE
key_id = 'e818b1423942cbb03aa3f80c88b24cc06c0b1809c44c4b6defb01e1271fdf215'
AND (
token = 'PhhVvJV4osBuaSb4u12tFbQoljsH4mKMkDLYh2e7OS4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)