UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZgVFosPp1+NGw6c9iRxzKl9fIByTGPN2wOCl4jqdkxw='
WHERE
key_id = '037822d69cd23e0d6c64cdb04ea5e20c9e8a0519b06774e981f45205ca6cf220'
AND (
token = 'ZgVFosPp1+NGw6c9iRxzKl9fIByTGPN2wOCl4jqdkxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)