UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zZIVCvqeAy4qbw3FTJjhWFRpIZeVyMDe5LeB6JLdcr0='
WHERE
key_id = '346c38c63405bea1348bcd1ac4d23a8c11d05e8bda6237a4130f801fd79836c7'
AND (
token = 'zZIVCvqeAy4qbw3FTJjhWFRpIZeVyMDe5LeB6JLdcr0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)