UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B6rcLxQi/XC8kaE2Zzvt7XzyPrIhCS6jDYzPdT22Ak0='
WHERE
key_id = 'b565477d55686f84fb1758f11dc4c25b12e7f36ae54113d84341c2861025b8b3'
AND (
token = 'B6rcLxQi/XC8kaE2Zzvt7XzyPrIhCS6jDYzPdT22Ak0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)