UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tDtTw019ExgGBssPf/6EKzfYqYFRp/Bli/t4cvTwFoA='
WHERE
key_id = 'c12f56713bbb6e2d50e84df50eedaf117c80638495d4a5e6f50a212af252c500'
AND (
token = 'tDtTw019ExgGBssPf/6EKzfYqYFRp/Bli/t4cvTwFoA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)