UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zHWGW7jDf2FTvN838Afp93b7kCSA2I2nsDDyMQ2cPvE='
WHERE
key_id = '81f7fbd4480600f06aa1208aa8ce60aa8869385efd5f4bfcdcec318f134420ab'
AND (
token = 'zHWGW7jDf2FTvN838Afp93b7kCSA2I2nsDDyMQ2cPvE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)