UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7qhZY8YZHiuTKAF5SSeWgwdi5YBHa152nUXiHIYRDMo='
WHERE
key_id = '12e54601719fa81c610bed2b4fcf2d3bd308cf39545c56490b0a202d47bc6774'
AND (
token = '7qhZY8YZHiuTKAF5SSeWgwdi5YBHa152nUXiHIYRDMo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)