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