UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qy2ssQLKX0YwZKjA3lm09k33ZnHLIaC1tbjfdUl+bcM='
WHERE
key_id = '5c738c7933ca2b331eae760d9632ee42a406eea6875b917c142a99cace79bb3d'
AND (
token = 'qy2ssQLKX0YwZKjA3lm09k33ZnHLIaC1tbjfdUl+bcM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)