UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SPmHrgWoy4FZn9m9UewMXa2UgmybbFDH7I2CC8xakrc='
WHERE
key_id = '9c3beeba45a15ff4f154f25a0295da8624d7b0cd89aa165ae99e8973dc34db31'
AND (
token = 'SPmHrgWoy4FZn9m9UewMXa2UgmybbFDH7I2CC8xakrc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)