UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UcMh7h9dPBwYTj0RwKnnoEKG6ysYkThF42+caxD66Vc='
WHERE
key_id = '4f78a5b2288aa707e05f420e3513c43057f04023c0d6ce5566137ee07782557a'
AND (
token = 'UcMh7h9dPBwYTj0RwKnnoEKG6ysYkThF42+caxD66Vc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)