UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CACP6EmLhyODMIWIUABB5xBjdFgGjRakGfvpD44pRVI='
WHERE
key_id = 'ad832327a15e08706d0b3d4a803ea30bcbb4b9d3ae8cec86fd8c5bbc4acd4ce8'
AND (
token = 'CACP6EmLhyODMIWIUABB5xBjdFgGjRakGfvpD44pRVI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)