UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UXORApPBRJspfqgO6bzknAiM/tzj7+8kIp8Lk+6GPPQ='
WHERE
key_id = '28c862361bcd5f21292448a76b28b19ff82ac59e0acc7561da7e6e31234acf92'
AND (
token = 'UXORApPBRJspfqgO6bzknAiM/tzj7+8kIp8Lk+6GPPQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)