UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x6SMipQE5lNQaB3ZgyBff8eRz48pl0GGqdZA9SKgXl0='
WHERE
key_id = '4f630c374b6fc309973e7bdaf20e2caf330ef0bdba7d065800c59ab589eb1817'
AND (
token = 'x6SMipQE5lNQaB3ZgyBff8eRz48pl0GGqdZA9SKgXl0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)