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