UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7MxuZABwH5kbdV4Mjy5fmkugvs1Jv9e9BKMInriSkBo='
WHERE
key_id = '59293233a777a474f8790719706a3a3aa94f23304cabfeb3f6420b0c27d97761'
AND (
token = '7MxuZABwH5kbdV4Mjy5fmkugvs1Jv9e9BKMInriSkBo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)