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