UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yghIKfZfhDWACFqREuHTbDVGvMed2iOeQCVp9SWSJjA='
WHERE
key_id = '4677df78c269d93fdd6add3a62a0031af4c8c9edbf946b99c01ee2a2a56ba411'
AND (
token = 'yghIKfZfhDWACFqREuHTbDVGvMed2iOeQCVp9SWSJjA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)