UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RGYHG1twG/in6WnC1FOE/s8B00kuFQeE/7+oKjpICkw='
WHERE
key_id = '8e7257070ef1a7135ec23ae394ca94a16f4721ff9d120a24825562594a72f7cf'
AND (
token = 'RGYHG1twG/in6WnC1FOE/s8B00kuFQeE/7+oKjpICkw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)