UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5p4nJNRpwoftilAHNs3x08HDqWHERnWOYgWYwn2ZKAg='
WHERE
key_id = 'd4fdb0ecc27973e19b9034abee567ad16abbe09cce953a1b223d8209b0756605'
AND (
token = '5p4nJNRpwoftilAHNs3x08HDqWHERnWOYgWYwn2ZKAg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)