UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jzs/0fKm5BMWe5OAhLeZbBEyJKWkuYRGlM6s+lZ5/Bw='
WHERE
key_id = 'a0e7f416dc1362993789fa057a315dab1108065ea89fd0178ca36dfbc53729b8'
AND (
token = 'Jzs/0fKm5BMWe5OAhLeZbBEyJKWkuYRGlM6s+lZ5/Bw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)