UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xJU8AjzPBekW6IFNSHRbMhhkRzyYr0qgofY6vIrzqx8='
WHERE
key_id = '29ebd1e51e5bcace06034d2cfed312bdc62289b24f5125ad6ddc87d10dac4e80'
AND (
token = 'xJU8AjzPBekW6IFNSHRbMhhkRzyYr0qgofY6vIrzqx8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)