UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FghUi67YIyOoCL0SFdPCIakYo0jzTJr2PhVvqE7e0PA='
WHERE
key_id = '1a639837334115efc7ae16b46d5cc33ae751205a0a1bbca5462156c55bbb094e'
AND (
token = 'FghUi67YIyOoCL0SFdPCIakYo0jzTJr2PhVvqE7e0PA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)