UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VEVAiZ14NkaXQRyb6FMa4fbd4pPyvy5/5A2lu9nXr/0='
WHERE
key_id = 'cc62def54107bbe5ec044850353e6b56fe228f2f408d9224f64c9bc632b502e9'
AND (
token = 'VEVAiZ14NkaXQRyb6FMa4fbd4pPyvy5/5A2lu9nXr/0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)