UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8qvXzda0kMeJhuSQb08SKlxtsRiNttP0LCRPw8kq2Mo='
WHERE
key_id = '820a1848230fd156d6dbc55a6fa4b10ba5ffed7dd4f63c5dcfb77cc569dfcb93'
AND (
token = '8qvXzda0kMeJhuSQb08SKlxtsRiNttP0LCRPw8kq2Mo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)