UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AoeitpIOfLo7jBU9SziXYf+Sv3oRyHCufdUN4El9CHE='
WHERE
key_id = '9efed12306be93d611594a2fb1667c150ee4e49ddf4c34a22c884151cf3e5fbb'
AND (
token = 'AoeitpIOfLo7jBU9SziXYf+Sv3oRyHCufdUN4El9CHE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)